Terri Leong ✭✭✭

Overview

Overview

Roles	Member
Badges	7

About Me

About Me

Not much happening here, yet.

Analytics

7

Posts

10

Visits

308

Points

Apr 23, 2021

Join Date

May 13, 2021

Last Active

Reactions

• Insightful 2

  2

• Activity
• Discussions1
• Comments6

• Re: How to automatically populate a cell with same info from another cell on the same row

  Terri Leong

  04/23/21
  An IF statement should produce the results you want. In the "Rooms" column, enter =IF(NOT(ISBLANK([Building 1st Floor Rooms]@row)), [Building 1st Floor Rooms]@row, IF(NOT(ISBLANK([Building …
  1 ·

• Re: Nested If with Vlookup

  Terri Leong

  04/27/21
  It looks like your syntax might just be off. Try "=IF([L2]@row = "Last, First", VLOOKUP([L3]@row, {POC}, 2, false), VLOOKUP([L2]@row, {POC}, 2, false))"
  1 ·